---
redirect_from:
  - /config/databases/firebolt
---

# Firebolt

<WarningBox>

The driver for Firebolt is supported by its vendor. Please report any issues to
their [Help Center][firebolt-help].

</WarningBox>

## Prerequisites

- The id/secret (client id/client secret) for your [Firebolt][firebolt] [service account][firebolt-service-accounts]

## Setup

### Manual

Add the following to a `.env` file in your Cube project:

```dotenv
CUBEJS_DB_NAME=firebolt_database
CUBEJS_DB_USER=aaaa-bbb-3244-wwssd
CUBEJS_DB_PASS=**********
CUBEJS_FIREBOLT_ACCOUNT=cube
CUBEJS_FIREBOLT_ENGINE_NAME=engine_name
```

## Environment Variables

| Environment Variable           | Description                                                                         | Possible Values                                                         | Required |
| ------------------------------ | ----------------------------------------------------------------------------------- | ----------------------------------------------------------------------- | :------: |
| `CUBEJS_DB_NAME`               | The name of the database to connect to                                              | A valid database name                                                   |    ✅    |
| `CUBEJS_DB_USER`               | A service account ID for accessing Firebolt programmatically                        | A valid service id                                                      |    ✅    |
| `CUBEJS_DB_PASS`               | A service account secret for accessing Firebolt programmatically                    | A valid service secret                                                  |    ✅    |
| `CUBEJS_FIREBOLT_ACCOUNT`      | Account name                                                                        | An account name                                                         |    ✅    |
| `CUBEJS_FIREBOLT_ENGINE_NAME`  | Engine name to connect to                                                           | A valid engine name                                                     |    ✅    |
| `CUBEJS_FIREBOLT_API_ENDPOINT` | Firebolt API endpoint. Used for authentication                                      | `api.dev.firebolt.io`, `api.staging.firebolt.io`, `api.app.firebolt.io` |    -     |
| `CUBEJS_CONCURRENCY`           | The number of concurrent connections each queue has to the database. Default is `5` | A valid number                                                          |    ❌    |
| `CUBEJS_DB_MAX_POOL`           | The maximum number of concurrent database connections to pool. Default is `20`      | A valid number                                                          |    ❌    |

[firebolt]: https://www.firebolt.io/
[firebolt-help]: https://help.firebolt.io/
[firebolt-service-accounts]: https://docs.firebolt.io/godocs/Guides/managing-your-organization/service-accounts.html
